About

Column {data-width=400, vertical_layout: scroll}

Purpose of the dashboard

The dashboard is to examine hotel cancellations and factors associated with hotel cancellations in the United States between 2015 and 2017.

Column {data-width=400, overflow-x: auto, vertical_layout: scroll}

Original Data

The dataset is included in TidyTuesday, 2020-02-11. The original dataset comes from an open hotel booking demand dataset from Antonio, Almeida and Nunes, 2019. This dataset includes bookings of resort hotels or city hotels between the 1st of July of 2015 and the 31st of August 2017, including bookings that effectively arrived and bookings that were canceled.

Dashboard Author

Kening Jiang, MHS

Email

Github

Google Scholar

The Data

Column

Data Dictionary

Glimpse of the Dataset

Column {data-width=350, overflow-x: auto, vertical_layout: scroll}

Characteristics of hotel bookings overall and by cancellation

Overall
(N=2097)
No
(N=1596)
Yes
(N=501)
Type of hotel
City Hotel 1618 (77.2%) 1189 (74.5%) 429 (85.6%)
Resort Hotel 479 (22.8%) 407 (25.5%) 72 (14.4%)
Number of days between booking and arrival
Mean (SD) 77.2 (82.7) 70.7 (82.6) 97.8 (79.8)
Median [Min, Max] 51.0 [0, 542] 40.0 [0, 542] 77.0 [0, 327]
Year of arrival date
2015 180 (8.6%) 180 (11.3%) 0 (0%)
2016 963 (45.9%) 748 (46.9%) 215 (42.9%)
2017 954 (45.5%) 668 (41.9%) 286 (57.1%)
Season of arrival date
Spring 589 (28.1%) 426 (26.7%) 163 (32.5%)
Summer 851 (40.6%) 616 (38.6%) 235 (46.9%)
Fall 412 (19.6%) 354 (22.2%) 58 (11.6%)
Winter 245 (11.7%) 200 (12.5%) 45 (9.0%)
Number of weekend nights stayed
Mean (SD) 0.855 (0.929) 0.812 (0.921) 0.992 (0.942)
Median [Min, Max] 1.00 [0, 13.0] 1.00 [0, 13.0] 1.00 [0, 5.00]
Number of week nights stayed
Mean (SD) 1.92 (1.67) 1.83 (1.64) 2.21 (1.73)
Median [Min, Max] 2.00 [0, 30.0] 1.00 [0, 30.0] 2.00 [0, 11.0]
Number of adults
Mean (SD) 1.88 (0.526) 1.86 (0.521) 1.95 (0.535)
Median [Min, Max] 2.00 [0, 4.00] 2.00 [0, 4.00] 2.00 [0, 3.00]
Number of children and babies
Mean (SD) 0.175 (0.534) 0.150 (0.492) 0.255 (0.644)
Median [Min, Max] 0 [0, 3.00] 0 [0, 3.00] 0 [0, 2.00]
Repeated guest
No 2078 (99.1%) 1578 (98.9%) 500 (99.8%)
Yes 19 (0.9%) 18 (1.1%) 1 (0.2%)
Number of changes to the booking
Mean (SD) 0.339 (0.866) 0.367 (0.922) 0.250 (0.654)
Median [Min, Max] 0 [0, 14.0] 0 [0, 14.0] 0 [0, 5.00]
Average daily rate, $
Mean (SD) 123 (51.6) 119 (51.4) 136 (50.1)
Median [Min, Max] 115 [0, 328] 109 [0, 328] 128 [0, 311]

Categorical Characteristics of bookings by cancellation

Column

Number of completed and cancelled hotel bookings by season and year

Number of completed and cancelled hotel bookings by hotel type

Continuous Characteristics of bookings by cancellation

Column

Average daily rate and time before arrival

Other continuous characteristics

Analysis